Property starting with A |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
Assortment
|
Assortment
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
AssortmentDescription
|
AssortmentDescription
|
String
|
|
160
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with C |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
ConditionCalculationMethod
|
ConditionCalcMethod
|
String
|
|
1
|
0
|
N
|
|
|
|
|
|
|
|
|
|
|
|
CreatedDate
|
SysCreated
|
Date
|
|
10
|
0
|
|
1753-01-01
|
9999-12-31
|
|
|
|
|
|
|
|
|
|
Creator
|
SysCreator
|
Number
|
|
10
|
0
|
HUMRESID
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with D |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
DayOfTheMonth
|
DayOfTheMonth
|
Number
|
|
5
|
0
|
0
|
0
|
99
|
|
|
|
|
|
|
|
|
|
Description
|
Description
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Description1
|
Description1
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Description2
|
Description2
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Description3
|
Description3
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Description4
|
Description4
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
DiscountSurchargeAmount
|
CS_SD_Amount
|
String
|
|
1
|
0
|
B
|
|
|
|
|
|
|
|
|
|
|
B,5741,Settlement dsct | K,10494,Credit surcharge |
|
DueDateType
|
DueDateType
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
1,14320,Date + payment term | 2,14519,Date -> end of the month -> day of the month | 3,14321,Date -> end of the next month -> day of the month | 4,14323,Date + payment term -> end of the month -> day of the month | 5,14322,Date + payment term -> end of the next month -> day of the month | 6,14324,Date + payment term -> x.end of the month -> day of the month | 7,30935,Date + payment term (in months) | 8,30936,Date -> end of month + x months | 9,23921,Terms | A,13878,Invoice date + payment term | B,13879,Order date + payment term | C,13880,Fulfillment date + payment term | D,13881,Order confirmation date + payment term |
|
DueDateType1
|
DueDateType1
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
1,14320,Date + payment term | 2,14519,Date -> end of the month -> day of the month | 3,14321,Date -> end of the next month -> day of the month | 7,30935,Date + payment term (in months) | 8,30936,Date -> end of month + x months |
|
DueDateType2
|
DueDateType2
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
1,14320,Date + payment term | 2,14519,Date -> end of the month -> day of the month | 3,14321,Date -> end of the next month -> day of the month | 7,30935,Date + payment term (in months) | 8,30936,Date -> end of month + x months |
|
DueDateType3
|
DueDateType3
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
1,14320,Date + payment term | 2,14519,Date -> end of the month -> day of the month | 3,14321,Date -> end of the next month -> day of the month | 7,30935,Date + payment term (in months) | 8,30936,Date -> end of month + x months |
|
DueDateType4
|
DueDateType4
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
1,14320,Date + payment term | 2,14519,Date -> end of the month -> day of the month | 3,14321,Date -> end of the next month -> day of the month | 7,30935,Date + payment term (in months) | 8,30936,Date -> end of month + x months |
|
DueDateType5
|
DueDateType5
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
1,14320,Date + payment term | 2,14519,Date -> end of the month -> day of the month | 3,14321,Date -> end of the next month -> day of the month | 7,30935,Date + payment term (in months) | 8,30936,Date -> end of month + x months |
|
DueDateTypeText
|
DueDateTypeText
|
String
|
|
40
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with G |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
GrossNetInvoicing
|
Gross_Net_Invoicing
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
B,9817,Calculate VAT on gross amounts | N,14012,Calculate VAT on net amounts |
|
Property starting with I |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
ID
|
ID
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
InterestRate
|
InterestRate
|
Double
|
|
10
|
2
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
Property starting with M |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
ModifiedDate
|
SysModified
|
Date
|
|
10
|
0
|
|
1753-01-01
|
9999-12-31
|
|
|
|
|
|
|
|
|
|
Modifier
|
SysModifier
|
Number
|
|
10
|
0
|
HUMRESID
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with N |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
NumberOfDays1
|
NumberOfDays1
|
Number
|
|
3
|
0
|
0
|
0
|
999
|
|
|
|
|
|
|
|
|
|
NumberOfDays2
|
NumberOfDays2
|
Number
|
|
3
|
0
|
0
|
0
|
999
|
|
|
|
|
|
|
|
|
|
NumberOfDays3
|
NumberOfDays3
|
Number
|
|
3
|
0
|
|
0
|
999
|
|
|
|
|
|
|
|
|
|
NumberOfMonths
|
NumberOfMonths
|
Number
|
|
5
|
0
|
0
|
0
|
99
|
|
|
|
|
|
|
|
|
|
Property starting with P |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
PayInInstallments
|
PayInInstallments
|
Number
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PaymentConditionCode
|
PaymentConditionCode
|
String
|
|
2
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Percentage
|
Percentage
|
Number
|
|
5
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
Percentage2
|
Percentage2
|
Number
|
|
5
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
Percentage3
|
Percentage3
|
Number
|
|
5
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with T |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
Term
|
Termijn
|
Number
|
|
3
|
0
|
0
|
0
|
999
|
|
|
|
|
|
|
|
|
|
Term1
|
Term1
|
Number
|
|
2
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Term2
|
Term2
|
Number
|
|
2
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Term3
|
Term3
|
Number
|
|
2
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Term4
|
Term4
|
Number
|
|
2
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Term5
|
Term5
|
Number
|
|
2
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|